Numeric remap example
A Numeric remap maps data in a numeric field. For example, a Numeric remap could map an income field into ranges of £10,000. A Numeric remap references data from an external file to create the data ranges.
The external file can be created in any text editor, for example, Windows Notepad.
The following example displays an external file to remap the Income column on the Person table.
The script is written in the following format:
NUMERIC, Full Table Name, Remap Fieldname, Existing Fieldname, External File Name,
Start Value Column Number, End Value Column Number, Label Column Number
If you are using the Data Transformation wizard, these entries relate to the column fields as follows:
| NUMERIC | Data Transformation function |
| Full Table Name | Parent Table |
| Remap Fieldname | Short name of decode |
| Existing Fieldname | Short name of column to decode |
| External File Name | Name of file containing decodes |
| Start Value Column Number | Column in file containing the minimum value |
| EndValue Column Number | Column in file containing the maximum value |
| Label Column Number | Column in file containing decodes |
| Note: | The Start Value Column Number is inclusive of the first value in the range and the End Value Column Number is exclusive of the final value in the range. |
The following example creates a new field called 'Income Decode' using the Income Decode.txt file from the Income column of the Customer table.
NUMERIC, [Demo].[Customer], Income Decode, Income, Income Decode.txt, 1,2,3
